package com.techysky.repository;

import java.io.Serializable;
import java.util.List;

import org.springframework.data.jpa.repository.Query;

import com.techysky.entity.PlanType;

public interface PlanTypeRepository extends CoreRepository<PlanType, Serializable> {

	
	
	
	@Query(value="select distinct  t1.*  from plan_manage t,plan_type t1  where  t.paln_type_id=t1.id  and t.user_id=?1  ", nativeQuery = true)
	List<PlanType> findAllByUserIdOrderByCreateDateDesc(String id);
	
}